ClassSectionLesson

EntityType | Independent
Logical Entity Name | ClassSectionLesson
Default Table Name | AdClassLesson
Logical Only | NO
Owner | dbo
Definition |
Note |

ClassSectionLesson Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(40) | NO |
LessonNumber |  | INTEGER | NO |
Type |  | CHAR(1) | YES |
PctFinalGrade |  | NUMERIC(5, 4) | NO |
LessonFormat |  | TINYINT | YES |
Note |  | TEXT | NO |
Text |  | TEXT | YES |
Image1 |  | VARCHAR(50) | YES |
Image2 |  | VARCHAR(50) | YES |
Image3 |  | VARCHAR(50) | YES |
Image4 |  | VARCHAR(50) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
ClassSectionId |  | INTEGER | YES |
LessonTypeId |  | INTEGER | YES |
ClassSectionLessonId |  | INTEGER | NO |
ClassSectionId |  | INTEGER | YES |

ClassSectionLesson Keys

Key Name | Key Type | Keys
AdClassLesson_AdLessonTypeID_N_N_IDX | Inversion Entry | LessonTypeId
AdClassLesson_AdClassLessonID_U_C_IDX | PrimaryKey | ClassSectionLessonId
AdClassLesson_adClassSchedID_N_N_IDX | Inversion Entry | ClassSectionId

ClassSectionLesson Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO
LessonType | Non-Identifying | Zero or One to Zero or More |  |  |  | LessonTypeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
LessonType | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdClassLessonFile | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdClassLessonSkill | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdEnrollLessonRetake | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdLessonPlanCourseMap | Non-Identifying | One To Zero or More |  |  |  |  | NO

ClassSectionLesson Check Constraints

Check Constraint Name | CheckConstraint

ClassSectionLesson Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ClassSectionLesson | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdClassLesson | NO |  |  |

ClassSectionLesson Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

ClassSectionLesson Data Movement Rules

Name | Type | Rule Text/Value